Power BI Projects

Retail Sales Analysis: Key Insights This retail sales analysis provides a snapshot of performance across multiple dimensions, including sales by location, payment methods, age demographics, and product metrics. Here are the key takeaways: Total Sales by Mall: Sales are segmented by major malls, including Kanyon, Metrocity, and Istinye, indicating a focus on high-traffic retail locations. The data suggests varying performance across these sites, which could inform targeted marketing or operational strategies. Payment Method Trends: Annual payment volumes range from £3.34M to £19.85M, with the highest figure (£19.85M) likely representing the most recent or peak year. This trend could reflect growth in customer spending or adoption of digital payment methods. Age Demographics: Two age groups account for 17.27% and 21.44% of sales, respectively. This highlights a potential opportunity to tailor promotions or inventory to these dominant demographics. Product Performance: The total product count stands at 298.71K, with sales figures scaling from £14.03M to £437M (highest observed value). The wide range suggests a diverse product portfolio, with certain high-value items driving significant revenue.

Sales Report: Key Insights 1. Regional Performance Revenue Distribution: East leads with £725.46K (31.58%), followed by Central (£678.78K, 29.55%) and West (£391.72K, 17.05%). Opportunity: South region’s data is missing; investigate potential underperformance or gaps. 2. Sales Trends Over Time (2014–2017) Yearly data suggests fluctuating performance. 2015–2016 likely saw peak sales (based on segment totals). Action: Drill deeper into 2017 metrics to identify decline causes (if any). 3. Segment & Sub-Category Analysis Top Segments: Corporate dominates (32.39% share), followed by Home Office (28.04%) and Consumer (16.39%). Sub-Categories: Highest sales: £223.84K (unspecified sub-category). Lowest: £1.30K (niche product).

Brazil E-Commerce Sales Analysis The Brazil E-Commerce Sales Analysis report presents a comprehensive overview of online retail performance across key metrics, payment methods, geographic regions, and customer feedback. Here's a concise data-driven narrative: 📊 Key Financial Metrics Total Payment Value: £16.01M, with a freight value of £2.25M, suggesting significant logistics involvement. Customer Engagement: 99.22K review scores collected across 74 product categories, reflecting a broad and actively reviewed product base. 💳 Payment Method Preferences Credit Cards dominate e-commerce transactions, accounting for 78.34% of payment value. Other methods like boleto (17.92%), vouchers (2.37%), and debit cards are used but far less frequently, indicating a strong preference for credit-based purchases. 📅 Sales Trend Over Time A consistent year-on-year growth is evident: 2016: £0.059M 2017: £7.25M 2018: £8.70M Monthly analysis shows peak sales in November and December 2018, likely driven by seasonal promotions (e.g., Black Friday). 🌍 Geographic Insights São Paulo (SP) leads with £6.00M, contributing over a third of total sales, followed by Rio de Janeiro (RJ) and Minas Gerais (MG). A long tail of states (e.g., AP, AC, AM) with smaller contributions highlights regional disparities in e-commerce activity. ⭐ Customer Review Distribution Reviews are generally positive: 5-star reviews constitute 57.78%, followed by 4-star (19.29%) and 3-star (11.51%) ratings. Negative reviews (2-star and 1-star) make up a minor share (around 5%), suggesting strong customer satisfaction.

Flight Analysis This report provides an analytical overview of airline operations in the U.S. during 2015, focusing on flight volumes, delays, cancellations, and contributing factors. Below is a concise summary of key insights: ✈️ Flight Operations Overview Scheduled Flights: 5.82 million Completed Flights: 5.73 million Cancelled Flights: 89.88K Diverted Flights: 15.19K Total Distance Flown: 4.79 billion miles The completion rate was high, with cancellations constituting approximately 1.5% of all scheduled flights. ⏱️ Delay Insights by Airline Top Delayed Airlines: Southwest (WN) led with 3.8M delays. Followed by American (AA): 2.8M, Delta (DL): 2.7M, and ExpressJet (EV): 2.4M. Smaller airlines like VX, HA, and F9 had fewer delays, reflecting either lower volumes or better punctuality. 📉 Reasons for Delays & Cancellations Delay Breakdown: Late aircraft arrival: 39.8% – the most common cause. Airline-specific issues: 32.2% Air system delays: 22.9% Weather: 5.0% – minor but impactful in isolated cases. Cancellations: Weather (28.11%) and Airline/Carrier Issues (54.35%) were the leading causes. 📅 Monthly Trends Total Flights by Month: July (515.91K) had the highest activity, followed by August and June. The quietest months were February and January, aligning with seasonal travel patterns. Aircraft Delays by Month: Peaked in July (3.1M), matching high traffic periods. Dropped significantly in October and November, then rose again in December. 🧭 Summary & Strategic Insights Operational Volume is heavily seasonal, with summer months seeing the highest activity and delays. Late aircraft arrivals and airline management issues are the leading delay causes—highlighting internal efficiency as a key area for improvement. Weather plays a lesser but notable role, especially in cancellations.

Video Game Sales Report This report offers an analytical snapshot of video game product performance by sales, profit, and regional distribution. It highlights key revenue drivers, product trends, and geographical profitability. 🎮 Sales and Product Performance Total Sales: £33.9K across 67 units sold. Top-Selling Product: PC games (20 units), followed closely by PlayStation (19 units). Despite lower unit sales, PlayStation delivered the highest profit (£1,600), followed by PC (£1,400), XBOX (£1,350), and Nintendo (£1,250), indicating higher margins on certain platforms. 📍 Regional Distribution West region contributed the largest share of sales (42.48%), with strong profits of £2.4K, predominantly from US customers. South (23.16%) and East (20.35%) regions followed, with Spain driving profit in the South (£1.4K) and India in the East (£0.9K). North had the lowest share (14.01%) and a modest profit of £0.7K, again led by Spain. 🌍 Profit by Country United States led with the highest profit contribution, solely from the West. Spain contributed significantly across both South and North regions. Other notable contributors include India (East) and Italy (South). 📌 Strategic Insights Focus on high-margin platforms like PlayStation and PC, especially in the West and South. US and Spain emerge as key profit-driving markets. Consider increasing marketing spend in the West and South, and evaluate potential growth strategies for the East and North, where contributions are currently lower.

Student Mental Health Analysis: Key Insights This dashboard provides an analysis of student mental health. Key findings include: Gender Distribution: The student population is predominantly male (75%) compared to female (26%). Year of Study: The number of students decreases significantly in later years, with Year 1 having the most students (43) and Year 4 the least (8). Mental Health Concerns: A notable portion of students report experiencing panic attacks (33%) and anxiety (66.34%). Approximately 35% of students report having depression. Popular Courses: BCS and Engineering are the most popular courses among students. Marital Status: The majority of students are not married (85%). CGPA by Year: CGPA distribution varies across the years of study. Year 1 shows a higher concentration of students in the lower CGPA ranges (0-1.99 and 2.00-2.49), while later years have more students in the higher ranges (3.00-3.49 and 3.50-4.00), indicating that academic performance may improve over time for some students.